A Large Scale Data Warehouse Application Case Study
نویسنده
چکیده
Large data warehouse applications are beginning to become more necessary as large amounts of data are collected from the day to day interactions of businesses and their customers. Businesses are now using these enormous amounts of data to decide how and where to advertise, what resources projects will require in the future, and to gauge the general direction of the company to keep it on track. This paper is a case study of the design and implementation of a 1+ terabyte data warehouse for marketing decision support from a systems design and administration perspective. It will include a brief discussion of software selection and a detailed look at the sizing, testing, tuning, and implementation of the data warehouse. The case study will address such issues as sizing, I/O subsystems, I/O bandwidth, backup issues, performance trade-offs, and day to day operations.
منابع مشابه
The design and development of a social science data warehouse: A case study of the Human Resources Development Data Warehouse Project of the Human Sciences Research Council, South Africa
This article focuses on the development of a data warehouse to facilitate government decision-making on national human resources development and to provide public access to information. A set of key challenges was confronted in the development of the data warehouse including: the conceptualisation, design, implementation and management of the data warehouse system. The underlying questions that...
متن کاملUsing Reference Models for Data Warehouse Metadata Management
Based on experience from applying the Common Warehouse Metamodel to metadata management at a large Swiss bank, the applicability of metadata reference models in complex application domains is analyzed. In order to explain the context of the case, the state-of-the-art of the Common Warehouse Metamodel and its application for data warehouse management are summarized. Based on the project experien...
متن کاملData Warehousing Requirements Collection and Definition: Analysis of a Failure
Defining data warehouse requirements is widely recognized as one of the most important steps in the larger data warehouse system development process. This paper examines the potential risks and pitfalls within the data warehouse requirement collection and definition process. A real scenario of a large-scale data warehouse implementation is given, and details of this project, which ultimately fa...
متن کاملA Practical Desalinization Model for Large Scale Application
Salinity of soil and water is the most important agricultural hazard in arid and semi-aridregions. In saline soils, yield production directly influences by soluble salts in the root zone aswell as by shallow water table depth. The first step for reclamation of such soils is reducingsalinity to optimum level by leaching. The objective of this study was to develop a practicalmodel to estimate wat...
متن کاملSaudi Aramco Exploration & Producing Data Warehouse: A Case Study
This paper focuses on the challenges faced when building a data warehouse dealing primarily with scientific or engineering data. Successfully applying data warehousing concepts to an engineering-specific database poses some challenges which vary from the usual textbook examples. This, coupled with the introduction of a new database technology (data warehouse), into a large organization with a m...
متن کامل